Overview

Brought to you by YData

Dataset statistics

Number of variables	44
Number of observations	5860
Missing cells	12839
Missing cells (%)	5.0%
Duplicate rows	11
Duplicate rows (%)	0.2%
Total size in memory	9.1 MiB
Average record size in memory	1.6 KiB

Variable types

Numeric	13
Categorical	21
Text	7
DateTime	1
Boolean	1
Unsupported	1

Alerts

`Category` has constant value "Default"	Constant
`Shipping Address Country` has constant value "IN"	Constant
`Billing Address Country` has constant value "IN"	Constant
`Shipping Method` has constant value "STD"	Constant
`Gift Wrap` has constant value "False"	Constant
`HSN Code` has constant value "62045300.0"	Constant
`GST Tax Type Code` has constant value "GST12"	Constant
`UTGST` has constant value "0"	Constant
`CESS` has constant value "0"	Constant
`UTGST Rate` has constant value "0"	Constant
`CESS Rate` has constant value "0"	Constant
`Sale Order Status` has constant value "COMPLETE"	Constant
`GSTIN` has constant value "09AAICN9819MIZL"	Constant
Dataset has 11 (0.2%) duplicate rows	Duplicates
`Billing Address Id` is highly overall correlated with `Shipping Address Id`	High correlation
`Billing Address Pincode` is highly overall correlated with `Billing Address State` and 5 other fields	High correlation
`Billing Address State` is highly overall correlated with `Billing Address Pincode` and 5 other fields	High correlation
`CGST` is highly overall correlated with `CGST Rate` and 4 other fields	High correlation
`CGST Rate` is highly overall correlated with `Billing Address Pincode` and 8 other fields	High correlation
`Channel Name` is highly overall correlated with `Discount` and 3 other fields	High correlation
`Discount` is highly overall correlated with `Channel Name` and 1 other fields	High correlation
`IGST` is highly overall correlated with `CGST` and 8 other fields	High correlation
`IGST Rate` is highly overall correlated with `Billing Address Pincode` and 9 other fields	High correlation
`Item Type Color` is highly overall correlated with `IGST` and 3 other fields	High correlation
`MRP` is highly overall correlated with `IGST` and 5 other fields	High correlation
`Prepaid Amount` is highly overall correlated with `Channel Name`	High correlation
`SGST` is highly overall correlated with `CGST` and 4 other fields	High correlation
`SGST Rate` is highly overall correlated with `Billing Address Pincode` and 8 other fields	High correlation
`Selling Price` is highly overall correlated with `IGST` and 4 other fields	High correlation
`Shipping Address Id` is highly overall correlated with `Billing Address Id`	High correlation
`Shipping Address Pincode` is highly overall correlated with `Billing Address Pincode` and 5 other fields	High correlation
`Shipping Address State` is highly overall correlated with `Billing Address Pincode` and 5 other fields	High correlation
`Shipping Courier Status` is highly overall correlated with `Shipping Tracking Status`	High correlation
`Shipping Tracking Status` is highly overall correlated with `Channel Name` and 1 other fields	High correlation
`Subtotal` is highly overall correlated with `Channel Name` and 4 other fields	High correlation
`Total Price` is highly overall correlated with `IGST` and 4 other fields	High correlation
`CGST Rate` is highly imbalanced (60.0%)	Imbalance
`IGST Rate` is highly imbalanced (59.7%)	Imbalance
`SGST Rate` is highly imbalanced (60.0%)	Imbalance
`Shipping Courier Status` is highly imbalanced (74.0%)	Imbalance
`Item Type Color` has 4961 (84.7%) missing values	Missing
`MRP` has 188 (3.2%) missing values	Missing
`Cost Price` has 5860 (100.0%) missing values	Missing
`GST Tax Type Code` has 1591 (27.2%) missing values	Missing
`Shipping Courier Status` has 98 (1.7%) missing values	Missing
`Shipping Tracking Status` has 98 (1.7%) missing values	Missing
`Cost Price` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Prepaid Amount` has 5195 (88.7%) zeros	Zeros
`Discount` has 1176 (20.1%) zeros	Zeros
`CGST` has 4926 (84.1%) zeros	Zeros
`IGST` has 934 (15.9%) zeros	Zeros
`SGST` has 4926 (84.1%) zeros	Zeros

Reproduction

Analysis started	2025-03-01 10:33:59.680903
Analysis finished	2025-03-01 10:34:43.810154
Duration	44.13 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

Shipping Address Id
Real number (ℝ)

High correlation

Distinct	5680
Distinct (%)	96.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19079918

Minimum	17037893
Maximum	20951988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	17037893
5-th percentile	17307195
Q1	18267788
median	18918412
Q3	20102973
95-th percentile	20824217
Maximum	20951988
Range	3914095
Interquartile range (IQR)	1835185

Descriptive statistics

Standard deviation	1091279.9
Coefficient of variation (CV)	0.05719521
Kurtosis	-1.0743422
Mean	19079918
Median Absolute Deviation (MAD)	810727
Skewness	0.11659087
Sum	1.1180832 × 10¹¹
Variance	1.1908919 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18030566	5	0.1%
17147660	4	0.1%
18634020	4	0.1%
18260913	4	0.1%
18603959	4	0.1%
18259525	4	0.1%
18409077	3	0.1%
18317699	3	0.1%
18504225	3	0.1%
18277293	3	0.1%
Other values (5670)	5823	99.4%

Value	Count	Frequency (%)
17037893	1	< 0.1%
17038427	1	< 0.1%
17039694	1	< 0.1%
17048514	1	< 0.1%
17052967	1	< 0.1%
17055540	1	< 0.1%
17057290	1	< 0.1%
17058666	1	< 0.1%
17058904	1	< 0.1%
17059345	1	< 0.1%

Value	Count	Frequency (%)
20951988	1	< 0.1%
20950770	1	< 0.1%
20949763	1	< 0.1%
20949385	1	< 0.1%
20949182	1	< 0.1%
20948869	1	< 0.1%
20948572	1	< 0.1%
20948430	1	< 0.1%
20948416	1	< 0.1%
20948258	1	< 0.1%

Category
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.4 KiB

Default	5860

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	41020
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Default
2nd row	Default
3rd row	Default
4th row	Default
5th row	Default

Common Values

Value	Count	Frequency (%)
Default	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
default	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
D	5860	14.3%
e	5860	14.3%
f	5860	14.3%
a	5860	14.3%
u	5860	14.3%
l	5860	14.3%
t	5860	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	35160	85.7%
Uppercase Letter	5860	14.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5860	16.7%
f	5860	16.7%
a	5860	16.7%
u	5860	16.7%
l	5860	16.7%
t	5860	16.7%

Uppercase Letter

Value	Count	Frequency (%)
D	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	41020	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	5860	14.3%
e	5860	14.3%
f	5860	14.3%
a	5860	14.3%
u	5860	14.3%
l	5860	14.3%
t	5860	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41020	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	5860	14.3%
e	5860	14.3%
f	5860	14.3%
a	5860	14.3%
u	5860	14.3%
l	5860	14.3%
t	5860	14.3%

Invoice Code
Text

Distinct	5680
Distinct (%)	96.9%
Missing	0
Missing (%)	0.0%
Memory size	414.4 KiB

Length

Max length	16
Median length	16
Mean length	15.387201
Min length	13

Characters and Unicode

Total characters	90169
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5525 ?
Unique (%)	94.3%

Sample

1st row	NIMAT25F01090
2nd row	NIMAT25F01091
3rd row	NIMAT25F01092
4th row	I0925NC000006459
5th row	I0925NC000006454

Value	Count	Frequency (%)
i0925nc000004025	5	0.1%
i0925nc000005015	4	0.1%
i0925nc000004335	4	0.1%
i0925nc000004990	4	0.1%
i0925nc000004333	4	0.1%
i0925nc000003225	4	0.1%
i0925nc000004247	3	0.1%
i0925nc000005149	3	0.1%
nimat25f00854	3	0.1%
nimat25f00163	3	0.1%
Other values (5670)	5823	99.4%

Most occurring characters

Value	Count	Frequency (%)
0	31769	35.2%
5	8687	9.6%
2	7702	8.5%
9	6377	7.1%
I	5860	6.5%
N	5860	6.5%
C	4663	5.2%
4	2825	3.1%
6	2763	3.1%
3	2536	2.8%
Other values (7)	11127	12.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	68998	76.5%
Uppercase Letter	21171	23.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	31769	46.0%
5	8687	12.6%
2	7702	11.2%
9	6377	9.2%
4	2825	4.1%
6	2763	4.0%
3	2536	3.7%
7	2507	3.6%
1	2138	3.1%
8	1694	2.5%

Uppercase Letter

Value	Count	Frequency (%)
I	5860	27.7%
N	5860	27.7%
C	4663	22.0%
M	1197	5.7%
A	1197	5.7%
T	1197	5.7%
F	1197	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	68998	76.5%
Latin	21171	23.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	31769	46.0%
5	8687	12.6%
2	7702	11.2%
9	6377	9.2%
4	2825	4.1%
6	2763	4.0%
3	2536	3.7%
7	2507	3.6%
1	2138	3.1%
8	1694	2.5%

Latin

Value	Count	Frequency (%)
I	5860	27.7%
N	5860	27.7%
C	4663	22.0%
M	1197	5.7%
A	1197	5.7%
T	1197	5.7%
F	1197	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90169	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	31769	35.2%
5	8687	9.6%
2	7702	8.5%
9	6377	7.1%
I	5860	6.5%
N	5860	6.5%
C	4663	5.2%
4	2825	3.1%
6	2763	3.1%
3	2536	2.8%
Other values (7)	11127	12.3%

Invoice Created
Date

Distinct	392
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Memory size	45.9 KiB

Minimum	2024-01-10 09:59:00
Maximum	2025-12-02 10:48:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Shipping Address City
Text

Distinct	955
Distinct (%)	16.3%
Missing	0
Missing (%)	0.0%
Memory size	370.7 KiB

Length

Max length	21
Median length	18
Mean length	7.7609215
Min length	3

Characters and Unicode

Total characters	45479
Distinct characters	56
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	442 ?
Unique (%)	7.5%

Sample

1st row	Raebareli
2nd row	Phagwara
3rd row	Berhampore
4th row	Hyderabad
5th row	Kolkata

Value	Count	Frequency (%)
delhi	495	7.4%
new	330	4.9%
mumbai	330	4.9%
bangalore	280	4.2%
pune	200	3.0%
gurgaon	181	2.7%
noida	157	2.4%
hyderabad	147	2.2%
nagar	122	1.8%
bengaluru	118	1.8%
Other values (918)	4308	64.6%

Most occurring characters

Value	Count	Frequency (%)
a	8240	18.1%
r	3437	7.6%
u	2777	6.1%
i	2597	5.7%
e	2552	5.6%
n	2411	5.3%
h	2306	5.1%
d	1916	4.2%
l	1841	4.0%
o	1640	3.6%
Other values (46)	15762	34.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	37624	82.7%
Uppercase Letter	6869	15.1%
Space Separator	879	1.9%
Other Punctuation	74	0.2%
Open Punctuation	10	< 0.1%
Close Punctuation	10	< 0.1%
Decimal Number	8	< 0.1%
Dash Punctuation	5	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	8240	21.9%
r	3437	9.1%
u	2777	7.4%
i	2597	6.9%
e	2552	6.8%
n	2411	6.4%
h	2306	6.1%
d	1916	5.1%
l	1841	4.9%
o	1640	4.4%
Other values (15)	7907	21.0%

Uppercase Letter

Value	Count	Frequency (%)
B	915	13.3%
N	800	11.6%
G	686	10.0%
D	627	9.1%
M	565	8.2%
P	430	6.3%
A	393	5.7%
K	383	5.6%
J	304	4.4%
S	282	4.1%
Other values (14)	1484	21.6%

Decimal Number

Value	Count	Frequency (%)
2	4	50.0%
4	4	50.0%

Space Separator

Value	Count	Frequency (%)
	879	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	74	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	10	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	10	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44493	97.8%
Common	986	2.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	8240	18.5%
r	3437	7.7%
u	2777	6.2%
i	2597	5.8%
e	2552	5.7%
n	2411	5.4%
h	2306	5.2%
d	1916	4.3%
l	1841	4.1%
o	1640	3.7%
Other values (39)	14776	33.2%

Common

Value	Count	Frequency (%)
	879	89.1%
,	74	7.5%
(	10	1.0%
)	10	1.0%
-	5	0.5%
2	4	0.4%
4	4	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	45479	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	8240	18.1%
r	3437	7.6%
u	2777	6.1%
i	2597	5.7%
e	2552	5.6%
n	2411	5.3%
h	2306	5.1%
d	1916	4.2%
l	1841	4.0%
o	1640	3.6%
Other values (46)	15762	34.7%

Shipping Address State
Categorical

High correlation

Distinct	35
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	380.8 KiB

Uttar Pradesh	935
Maharashtra	830
Delhi	495
Karnataka	482
Haryana	470
Other values (30)	2648

Length

Max length	40
Median length	17
Mean length	9.5187713
Min length	3

Characters and Unicode

Total characters	55780
Distinct characters	42
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Uttar Pradesh
2nd row	Punjab
3rd row	West Bengal
4th row	Telangana
5th row	West Bengal

Common Values

Value	Count	Frequency (%)
Uttar Pradesh	935	16.0%
Maharashtra	830	14.2%
Delhi	495	8.4%
Karnataka	482	8.2%
Haryana	470	8.0%
Madhya Pradesh	340	5.8%
Gujarat	310	5.3%
Rajasthan	281	4.8%
Bihar	273	4.7%
West Bengal	215	3.7%
Other values (25)	1229	21.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	1390	18.1%
uttar	935	12.2%
maharashtra	830	10.8%
delhi	495	6.4%
karnataka	482	6.3%
haryana	470	6.1%
madhya	340	4.4%
gujarat	310	4.0%
rajasthan	281	3.7%
bihar	273	3.6%
Other values (36)	1877	24.4%

Most occurring characters

Value	Count	Frequency (%)
a	13859	24.8%
r	6081	10.9%
h	5410	9.7%
t	4332	7.8%
s	3148	5.6%
e	2550	4.6%
n	2281	4.1%
d	2280	4.1%
	1823	3.3%
P	1533	2.7%
Other values (32)	12483	22.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	46277	83.0%
Uppercase Letter	7631	13.7%
Space Separator	1823	3.3%
Other Punctuation	49	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	13859	29.9%
r	6081	13.1%
h	5410	11.7%
t	4332	9.4%
s	3148	6.8%
e	2550	5.5%
n	2281	4.9%
d	2280	4.9%
i	1235	2.7%
l	1093	2.4%
Other values (12)	4008	8.7%

Uppercase Letter

Value	Count	Frequency (%)
P	1533	20.1%
M	1176	15.4%
U	1005	13.2%
K	577	7.6%
D	502	6.6%
H	499	6.5%
B	488	6.4%
G	338	4.4%
T	297	3.9%
R	281	3.7%
Other values (8)	935	12.3%

Space Separator

Value	Count	Frequency (%)
	1823	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	49	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	53908	96.6%
Common	1872	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	13859	25.7%
r	6081	11.3%
h	5410	10.0%
t	4332	8.0%
s	3148	5.8%
e	2550	4.7%
n	2281	4.2%
d	2280	4.2%
P	1533	2.8%
i	1235	2.3%
Other values (30)	11199	20.8%

Common

Value	Count	Frequency (%)
	1823	97.4%
&	49	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55780	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	13859	24.8%
r	6081	10.9%
h	5410	9.7%
t	4332	7.8%
s	3148	5.6%
e	2550	4.6%
n	2281	4.1%
d	2280	4.1%
	1823	3.3%
P	1533	2.7%
Other values (32)	12483	22.4%

Shipping Address Country
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	337.8 KiB

IN	5860

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	11720
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IN
2nd row	IN
3rd row	IN
4th row	IN
5th row	IN

Common Values

Value	Count	Frequency (%)
IN	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
in	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11720	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11720	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11720	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Shipping Address Pincode
Real number (ℝ)

High correlation

Distinct	2104
Distinct (%)	35.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	395816.75

Minimum	110001
Maximum	855101
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	110001
5-th percentile	110060
Q1	201306
median	400064
Q3	560024
95-th percentile	803214.05
Maximum	855101
Range	745100
Interquartile range (IQR)	358718

Descriptive statistics

Standard deviation	218087.94
Coefficient of variation (CV)	0.55098209
Kurtosis	-0.78969982
Mean	395816.75
Median Absolute Deviation (MAD)	172063
Skewness	0.43807072
Sum	2.3194861 × 10⁹
Variance	4.7562349 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201301	105	1.8%
122001	75	1.3%
122002	36	0.6%
401107	35	0.6%
201306	34	0.6%
110085	33	0.6%
560037	27	0.5%
122003	25	0.4%
560068	25	0.4%
560035	24	0.4%
Other values (2094)	5441	92.8%

Value	Count	Frequency (%)
110001	3	0.1%
110002	1	< 0.1%
110003	3	0.1%
110005	7	0.1%
110007	12	0.2%
110008	13	0.2%
110009	18	0.3%
110010	2	< 0.1%
110012	2	< 0.1%
110014	2	< 0.1%

Value	Count	Frequency (%)
855101	2	< 0.1%
854327	1	< 0.1%
854326	1	< 0.1%
854318	2	< 0.1%
854311	2	< 0.1%
854304	1	< 0.1%
854301	1	< 0.1%
854205	2	< 0.1%
854109	1	< 0.1%
854105	1	< 0.1%

Billing Address Id
Real number (ℝ)

High correlation

Distinct	5680
Distinct (%)	96.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19079918

Minimum	17037894
Maximum	20951989
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	17037894
5-th percentile	17307195
Q1	18267788
median	18918412
Q3	20102973
95-th percentile	20824217
Maximum	20951989
Range	3914095
Interquartile range (IQR)	1835185

Descriptive statistics

Standard deviation	1091279.9
Coefficient of variation (CV)	0.057195206
Kurtosis	-1.0743422
Mean	19079918
Median Absolute Deviation (MAD)	810727
Skewness	0.1165908
Sum	1.1180832 × 10¹¹
Variance	1.1908918 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18030566	5	0.1%
17147660	4	0.1%
18634020	4	0.1%
18260913	4	0.1%
18603959	4	0.1%
18259525	4	0.1%
18409077	3	0.1%
18317699	3	0.1%
18504226	3	0.1%
18277293	3	0.1%
Other values (5670)	5823	99.4%

Value	Count	Frequency (%)
17037894	1	< 0.1%
17038428	1	< 0.1%
17039695	1	< 0.1%
17048515	1	< 0.1%
17052967	1	< 0.1%
17055540	1	< 0.1%
17057290	1	< 0.1%
17058667	1	< 0.1%
17058904	1	< 0.1%
17059345	1	< 0.1%

Value	Count	Frequency (%)
20951989	1	< 0.1%
20950770	1	< 0.1%
20949763	1	< 0.1%
20949385	1	< 0.1%
20949182	1	< 0.1%
20948869	1	< 0.1%
20948572	1	< 0.1%
20948430	1	< 0.1%
20948416	1	< 0.1%
20948258	1	< 0.1%

Billing Address City
Text

Distinct	955
Distinct (%)	16.3%
Missing	0
Missing (%)	0.0%
Memory size	370.7 KiB

Length

Max length	21
Median length	18
Mean length	7.7609215
Min length	3

Characters and Unicode

Total characters	45479
Distinct characters	56
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	442 ?
Unique (%)	7.5%

Sample

1st row	Raebareli
2nd row	Phagwara
3rd row	Berhampore
4th row	Hyderabad
5th row	Kolkata

Value	Count	Frequency (%)
delhi	495	7.4%
new	330	4.9%
mumbai	330	4.9%
bangalore	280	4.2%
pune	200	3.0%
gurgaon	181	2.7%
noida	157	2.4%
hyderabad	147	2.2%
nagar	122	1.8%
bengaluru	118	1.8%
Other values (918)	4308	64.6%

Most occurring characters

Value	Count	Frequency (%)
a	8240	18.1%
r	3437	7.6%
u	2777	6.1%
i	2597	5.7%
e	2552	5.6%
n	2411	5.3%
h	2306	5.1%
d	1916	4.2%
l	1841	4.0%
o	1640	3.6%
Other values (46)	15762	34.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	37624	82.7%
Uppercase Letter	6869	15.1%
Space Separator	879	1.9%
Other Punctuation	74	0.2%
Open Punctuation	10	< 0.1%
Close Punctuation	10	< 0.1%
Decimal Number	8	< 0.1%
Dash Punctuation	5	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	8240	21.9%
r	3437	9.1%
u	2777	7.4%
i	2597	6.9%
e	2552	6.8%
n	2411	6.4%
h	2306	6.1%
d	1916	5.1%
l	1841	4.9%
o	1640	4.4%
Other values (15)	7907	21.0%

Uppercase Letter

Value	Count	Frequency (%)
B	915	13.3%
N	800	11.6%
G	686	10.0%
D	627	9.1%
M	565	8.2%
P	430	6.3%
A	393	5.7%
K	383	5.6%
J	304	4.4%
S	282	4.1%
Other values (14)	1484	21.6%

Decimal Number

Value	Count	Frequency (%)
2	4	50.0%
4	4	50.0%

Space Separator

Value	Count	Frequency (%)
	879	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	74	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	10	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	10	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44493	97.8%
Common	986	2.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	8240	18.5%
r	3437	7.7%
u	2777	6.2%
i	2597	5.8%
e	2552	5.7%
n	2411	5.4%
h	2306	5.2%
d	1916	4.3%
l	1841	4.1%
o	1640	3.7%
Other values (39)	14776	33.2%

Common

Value	Count	Frequency (%)
	879	89.1%
,	74	7.5%
(	10	1.0%
)	10	1.0%
-	5	0.5%
2	4	0.4%
4	4	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	45479	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	8240	18.1%
r	3437	7.6%
u	2777	6.1%
i	2597	5.7%
e	2552	5.6%
n	2411	5.3%
h	2306	5.1%
d	1916	4.2%
l	1841	4.0%
o	1640	3.6%
Other values (46)	15762	34.7%

Billing Address State
Categorical

High correlation

Distinct	35
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	380.8 KiB

Uttar Pradesh	935
Maharashtra	830
Delhi	495
Karnataka	482
Haryana	470
Other values (30)	2648

Length

Max length	40
Median length	17
Mean length	9.5187713
Min length	3

Characters and Unicode

Total characters	55780
Distinct characters	42
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Uttar Pradesh
2nd row	Punjab
3rd row	West Bengal
4th row	Telangana
5th row	West Bengal

Common Values

Value	Count	Frequency (%)
Uttar Pradesh	935	16.0%
Maharashtra	830	14.2%
Delhi	495	8.4%
Karnataka	482	8.2%
Haryana	470	8.0%
Madhya Pradesh	340	5.8%
Gujarat	310	5.3%
Rajasthan	281	4.8%
Bihar	273	4.7%
West Bengal	215	3.7%
Other values (25)	1229	21.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	1390	18.1%
uttar	935	12.2%
maharashtra	830	10.8%
delhi	495	6.4%
karnataka	482	6.3%
haryana	470	6.1%
madhya	340	4.4%
gujarat	310	4.0%
rajasthan	281	3.7%
bihar	273	3.6%
Other values (36)	1877	24.4%

Most occurring characters

Value	Count	Frequency (%)
a	13859	24.8%
r	6081	10.9%
h	5410	9.7%
t	4332	7.8%
s	3148	5.6%
e	2550	4.6%
n	2281	4.1%
d	2280	4.1%
	1823	3.3%
P	1533	2.7%
Other values (32)	12483	22.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	46277	83.0%
Uppercase Letter	7631	13.7%
Space Separator	1823	3.3%
Other Punctuation	49	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	13859	29.9%
r	6081	13.1%
h	5410	11.7%
t	4332	9.4%
s	3148	6.8%
e	2550	5.5%
n	2281	4.9%
d	2280	4.9%
i	1235	2.7%
l	1093	2.4%
Other values (12)	4008	8.7%

Uppercase Letter

Value	Count	Frequency (%)
P	1533	20.1%
M	1176	15.4%
U	1005	13.2%
K	577	7.6%
D	502	6.6%
H	499	6.5%
B	488	6.4%
G	338	4.4%
T	297	3.9%
R	281	3.7%
Other values (8)	935	12.3%

Space Separator

Value	Count	Frequency (%)
	1823	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	49	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	53908	96.6%
Common	1872	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	13859	25.7%
r	6081	11.3%
h	5410	10.0%
t	4332	8.0%
s	3148	5.8%
e	2550	4.7%
n	2281	4.2%
d	2280	4.2%
P	1533	2.8%
i	1235	2.3%
Other values (30)	11199	20.8%

Common

Value	Count	Frequency (%)
	1823	97.4%
&	49	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55780	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	13859	24.8%
r	6081	10.9%
h	5410	9.7%
t	4332	7.8%
s	3148	5.6%
e	2550	4.6%
n	2281	4.1%
d	2280	4.1%
	1823	3.3%
P	1533	2.7%
Other values (32)	12483	22.4%

Billing Address Country
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	337.8 KiB

IN	5860

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	11720
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IN
2nd row	IN
3rd row	IN
4th row	IN
5th row	IN

Common Values

Value	Count	Frequency (%)
IN	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
in	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11720	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11720	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11720	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	5860	50.0%
N	5860	50.0%

Billing Address Pincode
Real number (ℝ)

High correlation

Distinct	2104
Distinct (%)	35.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	395816.75

Minimum	110001
Maximum	855101
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	110001
5-th percentile	110060
Q1	201306
median	400064
Q3	560024
95-th percentile	803214.05
Maximum	855101
Range	745100
Interquartile range (IQR)	358718

Descriptive statistics

Standard deviation	218087.94
Coefficient of variation (CV)	0.55098209
Kurtosis	-0.78969982
Mean	395816.75
Median Absolute Deviation (MAD)	172063
Skewness	0.43807072
Sum	2.3194861 × 10⁹
Variance	4.7562349 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201301	105	1.8%
122001	75	1.3%
122002	36	0.6%
401107	35	0.6%
201306	34	0.6%
110085	33	0.6%
560037	27	0.5%
122003	25	0.4%
560068	25	0.4%
560035	24	0.4%
Other values (2094)	5441	92.8%

Value	Count	Frequency (%)
110001	3	0.1%
110002	1	< 0.1%
110003	3	0.1%
110005	7	0.1%
110007	12	0.2%
110008	13	0.2%
110009	18	0.3%
110010	2	< 0.1%
110012	2	< 0.1%
110014	2	< 0.1%

Value	Count	Frequency (%)
855101	2	< 0.1%
854327	1	< 0.1%
854326	1	< 0.1%
854318	2	< 0.1%
854311	2	< 0.1%
854304	1	< 0.1%
854301	1	< 0.1%
854205	2	< 0.1%
854109	1	< 0.1%
854105	1	< 0.1%

Shipping Method
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	343.5 KiB

STD	5860

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	17580
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	STD
2nd row	STD
3rd row	STD
4th row	STD
5th row	STD

Common Values

Value	Count	Frequency (%)
STD	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
std	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
S	5860	33.3%
T	5860	33.3%
D	5860	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	17580	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	5860	33.3%
T	5860	33.3%
D	5860	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17580	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	5860	33.3%
T	5860	33.3%
D	5860	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	5860	33.3%
T	5860	33.3%
D	5860	33.3%

Item SKU Code
Text

Distinct	440
Distinct (%)	7.5%
Missing	0
Missing (%)	0.0%
Memory size	393.3 KiB

Length

Max length	17
Median length	16
Mean length	11.706655
Min length	9

Characters and Unicode

Total characters	68601
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	72 ?
Unique (%)	1.2%

Sample

1st row	ADGRN035-M
2nd row	ADKSET151-2XL
3rd row	ADKSET147-L
4th row	ADYLW036-S
5th row	ADKSET261-L

Value	Count	Frequency (%)
adcrdset159-s	125	2.1%
adcrdset159-m	120	2.0%
adkset157-s	89	1.5%
adjmp145-s	87	1.5%
adkset148-m	87	1.5%
adkset157-m	84	1.4%
adcrdset159-l	83	1.4%
adcrdset159-xs	81	1.4%
adkset261-s	80	1.4%
adkset148-l	73	1.2%
Other values (430)	4951	84.5%

Most occurring characters

Value	Count	Frequency (%)
D	7450	10.9%
A	6529	9.5%
S	6388	9.3%
-	5860	8.5%
1	4335	6.3%
T	4245	6.2%
E	3976	5.8%
L	3021	4.4%
K	2729	4.0%
2	2666	3.9%
Other values (23)	21402	31.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	44797	65.3%
Decimal Number	17944	26.2%
Dash Punctuation	5860	8.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	7450	16.6%
A	6529	14.6%
S	6388	14.3%
T	4245	9.5%
E	3976	8.9%
L	3021	6.7%
K	2729	6.1%
X	2180	4.9%
M	1809	4.0%
R	1796	4.0%
Other values (12)	4674	10.4%

Decimal Number

Value	Count	Frequency (%)
1	4335	24.2%
2	2666	14.9%
0	2237	12.5%
5	1981	11.0%
6	1694	9.4%
4	1492	8.3%
7	1019	5.7%
8	875	4.9%
9	855	4.8%
3	790	4.4%

Dash Punctuation

Value	Count	Frequency (%)
-	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44797	65.3%
Common	23804	34.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	7450	16.6%
A	6529	14.6%
S	6388	14.3%
T	4245	9.5%
E	3976	8.9%
L	3021	6.7%
K	2729	6.1%
X	2180	4.9%
M	1809	4.0%
R	1796	4.0%
Other values (12)	4674	10.4%

Common

Value	Count	Frequency (%)
-	5860	24.6%
1	4335	18.2%
2	2666	11.2%
0	2237	9.4%
5	1981	8.3%
6	1694	7.1%
4	1492	6.3%
7	1019	4.3%
8	875	3.7%
9	855	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	68601	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	7450	10.9%
A	6529	9.5%
S	6388	9.3%
-	5860	8.5%
1	4335	6.3%
T	4245	6.2%
E	3976	5.8%
L	3021	4.4%
K	2729	4.0%
2	2666	3.9%
Other values (23)	21402	31.2%

Item Type Name
Text

Distinct	91
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	639.7 KiB

Length

Max length	89
Median length	77
Mean length	54.766041
Min length	18

Characters and Unicode

Total characters	320929
Distinct characters	52
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	0.1%

Sample

1st row	Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta
2nd row	Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta
3rd row	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta
4th row	Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta
5th row	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta

Value	Count	Frequency (%)
with	6046	12.7%
kurta	3423	7.2%
	2900	6.1%
dupatta	2725	5.7%
embroidered	1970	4.1%
women	1864	3.9%
churidar	1857	3.9%
regular	1494	3.1%
ethnic	1025	2.1%
sequinned	957	2.0%
Other values (94)	23469	49.2%

Most occurring characters

Value	Count	Frequency (%)
	41870	13.0%
r	25494	7.9%
t	24652	7.7%
a	24399	7.6%
e	23982	7.5%
i	20749	6.5%
o	14730	4.6%
u	13561	4.2%
d	12746	4.0%
h	12224	3.8%
Other values (42)	106522	33.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	230976	72.0%
Uppercase Letter	43374	13.5%
Space Separator	41870	13.0%
Other Punctuation	2903	0.9%
Dash Punctuation	1603	0.5%
Decimal Number	203	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	25494	11.0%
t	24652	10.7%
a	24399	10.6%
e	23982	10.4%
i	20749	9.0%
o	14730	6.4%
u	13561	5.9%
d	12746	5.5%
h	12224	5.3%
n	11731	5.1%
Other values (15)	46708	20.2%

Uppercase Letter

Value	Count	Frequency (%)
W	6644	15.3%
C	5130	11.8%
D	4088	9.4%
S	3983	9.2%
E	3743	8.6%
K	3592	8.3%
P	3378	7.8%
T	2560	5.9%
R	1926	4.4%
O	1087	2.5%
Other values (12)	7243	16.7%

Other Punctuation

Value	Count	Frequency (%)
&	2900	99.9%
,	3	0.1%

Space Separator

Value	Count	Frequency (%)
	41870	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1603	100.0%

Decimal Number

Value	Count	Frequency (%)
3	203	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	274350	85.5%
Common	46579	14.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	25494	9.3%
t	24652	9.0%
a	24399	8.9%
e	23982	8.7%
i	20749	7.6%
o	14730	5.4%
u	13561	4.9%
d	12746	4.6%
h	12224	4.5%
n	11731	4.3%
Other values (37)	90082	32.8%

Common

Value	Count	Frequency (%)
	41870	89.9%
&	2900	6.2%
-	1603	3.4%
3	203	0.4%
,	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	320929	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	41870	13.0%
r	25494	7.9%
t	24652	7.7%
a	24399	7.6%
e	23982	7.5%
i	20749	6.5%
o	14730	4.6%
u	13561	4.2%
d	12746	4.0%
h	12224	3.8%
Other values (42)	106522	33.2%

Item Type Color
Categorical

High correlation Missing

Distinct	10
Distinct (%)	1.1%
Missing	4961
Missing (%)	84.7%
Memory size	365.4 KiB

Burgandy	336
Cream	216
Green	215
Red	105
Teal	10
Other values (5)	17

Length

Max length	9
Median length	8
Mean length	5.8809789
Min length	3

Characters and Unicode

Total characters	5287
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.2%

Sample

1st row	Green
2nd row	Cream
3rd row	Cream
4th row	Cream
5th row	Burgandy

Common Values

Value	Count	Frequency (%)
Burgandy	336	5.7%
Cream	216	3.7%
Green	215	3.7%
Red	105	1.8%
Teal	10	0.2%
WHITE	9	0.2%
BLACK	3	0.1%
BEIGE	3	0.1%
Navy Blue	1	< 0.1%
GREEN	1	< 0.1%
(Missing)	4961	84.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
burgandy	336	37.3%
cream	216	24.0%
green	216	24.0%
red	105	11.7%
teal	10	1.1%
white	9	1.0%
black	3	0.3%
beige	3	0.3%
navy	1	0.1%
blue	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
r	767	14.5%
e	762	14.4%
a	563	10.6%
n	551	10.4%
d	441	8.3%
B	343	6.5%
u	337	6.4%
y	337	6.4%
g	336	6.4%
C	219	4.1%
Other values (15)	631	11.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4322	81.7%
Uppercase Letter	964	18.2%
Space Separator	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	343	35.6%
C	219	22.7%
G	219	22.7%
R	106	11.0%
T	19	2.0%
E	17	1.8%
I	12	1.2%
W	9	0.9%
H	9	0.9%
L	3	0.3%
Other values (3)	8	0.8%

Lowercase Letter

Value	Count	Frequency (%)
r	767	17.7%
e	762	17.6%
a	563	13.0%
n	551	12.7%
d	441	10.2%
u	337	7.8%
y	337	7.8%
g	336	7.8%
m	216	5.0%
l	11	0.3%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5286	> 99.9%
Common	1	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	767	14.5%
e	762	14.4%
a	563	10.7%
n	551	10.4%
d	441	8.3%
B	343	6.5%
u	337	6.4%
y	337	6.4%
g	336	6.4%
C	219	4.1%
Other values (14)	630	11.9%

Common

Value	Count	Frequency (%)
	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5287	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	767	14.5%
e	762	14.4%
a	563	10.6%
n	551	10.4%
d	441	8.3%
B	343	6.5%
u	337	6.4%
y	337	6.4%
g	336	6.4%
C	219	4.1%
Other values (15)	631	11.9%

Channel Name
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	387.1 KiB

MYNTRAPPMP	4663
NYKAA_FASHION	1197

Length

Max length	13
Median length	10
Mean length	10.612799
Min length	10

Characters and Unicode

Total characters	62191
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NYKAA_FASHION
2nd row	NYKAA_FASHION
3rd row	NYKAA_FASHION
4th row	MYNTRAPPMP
5th row	MYNTRAPPMP

Common Values

Value	Count	Frequency (%)
MYNTRAPPMP	4663	79.6%
NYKAA_FASHION	1197	20.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
myntrappmp	4663	79.6%
nykaa_fashion	1197	20.4%

Most occurring characters

Value	Count	Frequency (%)
P	13989	22.5%
M	9326	15.0%
A	8254	13.3%
N	7057	11.3%
Y	5860	9.4%
T	4663	7.5%
R	4663	7.5%
K	1197	1.9%
_	1197	1.9%
F	1197	1.9%
Other values (4)	4788	7.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	60994	98.1%
Connector Punctuation	1197	1.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	13989	22.9%
M	9326	15.3%
A	8254	13.5%
N	7057	11.6%
Y	5860	9.6%
T	4663	7.6%
R	4663	7.6%
K	1197	2.0%
F	1197	2.0%
S	1197	2.0%
Other values (3)	3591	5.9%

Connector Punctuation

Value	Count	Frequency (%)
_	1197	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	60994	98.1%
Common	1197	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	13989	22.9%
M	9326	15.3%
A	8254	13.5%
N	7057	11.6%
Y	5860	9.6%
T	4663	7.6%
R	4663	7.6%
K	1197	2.0%
F	1197	2.0%
S	1197	2.0%
Other values (3)	3591	5.9%

Common

Value	Count	Frequency (%)
_	1197	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	62191	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	13989	22.5%
M	9326	15.0%
A	8254	13.3%
N	7057	11.3%
Y	5860	9.4%
T	4663	7.5%
R	4663	7.5%
K	1197	1.9%
_	1197	1.9%
F	1197	1.9%
Other values (4)	4788	7.7%

Gift Wrap
Boolean

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.9 KiB

False	5860

Value	Count	Frequency (%)
False	5860	100.0%

HSN Code
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	43
Missing (%)	0.7%
Memory size	383.4 KiB

62045300.0	5817

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	58170
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	62045300.0
2nd row	62045300.0
3rd row	62045300.0
4th row	62045300.0
5th row	62045300.0

Common Values

Value	Count	Frequency (%)
62045300.0	5817	99.3%
(Missing)	43	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
62045300.0	5817	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	23268	40.0%
6	5817	10.0%
2	5817	10.0%
4	5817	10.0%
5	5817	10.0%
3	5817	10.0%
.	5817	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	52353	90.0%
Other Punctuation	5817	10.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	23268	44.4%
6	5817	11.1%
2	5817	11.1%
4	5817	11.1%
5	5817	11.1%
3	5817	11.1%

Other Punctuation

Value	Count	Frequency (%)
.	5817	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	58170	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	23268	40.0%
6	5817	10.0%
2	5817	10.0%
4	5817	10.0%
5	5817	10.0%
3	5817	10.0%
.	5817	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	58170	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	23268	40.0%
6	5817	10.0%
2	5817	10.0%
4	5817	10.0%
5	5817	10.0%
3	5817	10.0%
.	5817	10.0%

MRP
Real number (ℝ)

High correlation Missing

Distinct	32
Distinct (%)	0.6%
Missing	188
Missing (%)	3.2%
Infinite	0
Infinite (%)	0.0%
Mean	5329.8062

Minimum	1599
Maximum	12999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	1599
5-th percentile	3499
Q1	4299
median	4999
Q3	6499
95-th percentile	6999
Maximum	12999
Range	11400
Interquartile range (IQR)	2200

Descriptive statistics

Standard deviation	1311.6218
Coefficient of variation (CV)	0.24609183
Kurtosis	1.5761615
Mean	5329.8062
Median Absolute Deviation (MAD)	1000
Skewness	0.76161937
Sum	30230661
Variance	1720351.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
3999	884	15.1%
4999	638	10.9%
6499	548	9.4%
5999	423	7.2%
6599	404	6.9%
4499	342	5.8%
6299	320	5.5%
6999	303	5.2%
4599	282	4.8%
5499	252	4.3%
Other values (22)	1276	21.8%

Value	Count	Frequency (%)
1599	1	< 0.1%
1899	3	0.1%
2799	12	0.2%
2999	51	0.9%
3299	118	2.0%
3499	216	3.7%
3599	37	0.6%
3999	884	15.1%
4099	4	0.1%
4122	1	< 0.1%

Value	Count	Frequency (%)
12999	2	< 0.1%
10999	41	0.7%
8899	26	0.4%
7999	134	2.3%
7500	3	0.1%
7499	37	0.6%
6999	303	5.2%
6599	404	6.9%
6499	548	9.4%
6299	320	5.5%

Total Price
Real number (ℝ)

High correlation

Distinct	279
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3424.9193

Minimum	879
Maximum	8999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	879
5-th percentile	2239
Q1	2639
median	3330
Q3	4199
95-th percentile	4639
Maximum	8999
Range	8120
Interquartile range (IQR)	1560

Descriptive statistics

Standard deviation	919.10866
Coefficient of variation (CV)	0.26835922
Kurtosis	1.5546684
Mean	3424.9193
Median Absolute Deviation (MAD)	761
Skewness	0.48309537
Sum	20070027
Variance	844760.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3299	278	4.7%
3899	270	4.6%
4487	249	4.2%
2519	238	4.1%
4283	168	2.9%
2309	134	2.3%
4289	114	1.9%
4211	108	1.8%
3127	105	1.8%
2719	103	1.8%
Other values (269)	4093	69.8%

Value	Count	Frequency (%)
879	1	< 0.1%
1006	2	< 0.1%
1045	1	< 0.1%
1199	2	< 0.1%
1200	1	< 0.1%
1253	6	0.1%
1254	4	0.1%
1319	34	0.6%
1320	11	0.2%
1379	7	0.1%

Value	Count	Frequency (%)
8999	1	< 0.1%
7699	4	0.1%
7480	2	< 0.1%
7479	34	0.6%
6999	1	< 0.1%
6499	1	< 0.1%
6230	1	< 0.1%
5999	3	0.1%
5599	3	0.1%
5399	1	< 0.1%

Selling Price
Real number (ℝ)

High correlation

Distinct	279
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3424.9193

Minimum	879
Maximum	8999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	879
5-th percentile	2239
Q1	2639
median	3330
Q3	4199
95-th percentile	4639
Maximum	8999
Range	8120
Interquartile range (IQR)	1560

Descriptive statistics

Standard deviation	919.10866
Coefficient of variation (CV)	0.26835922
Kurtosis	1.5546684
Mean	3424.9193
Median Absolute Deviation (MAD)	761
Skewness	0.48309537
Sum	20070027
Variance	844760.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3299	278	4.7%
3899	270	4.6%
4487	249	4.2%
2519	238	4.1%
4283	168	2.9%
2309	134	2.3%
4289	114	1.9%
4211	108	1.8%
3127	105	1.8%
2719	103	1.8%
Other values (269)	4093	69.8%

Value	Count	Frequency (%)
879	1	< 0.1%
1006	2	< 0.1%
1045	1	< 0.1%
1199	2	< 0.1%
1200	1	< 0.1%
1253	6	0.1%
1254	4	0.1%
1319	34	0.6%
1320	11	0.2%
1379	7	0.1%

Value	Count	Frequency (%)
8999	1	< 0.1%
7699	4	0.1%
7480	2	< 0.1%
7479	34	0.6%
6999	1	< 0.1%
6499	1	< 0.1%
6230	1	< 0.1%
5999	3	0.1%
5599	3	0.1%
5399	1	< 0.1%

Cost Price
Unsupported

Missing Rejected Unsupported

Missing	5860
Missing (%)	100.0%
Memory size	45.9 KiB

Prepaid Amount
Real number (ℝ)

High correlation Zeros

Distinct	445
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	347.20062

Minimum	0
Maximum	7450
Zeros	5195
Zeros (%)	88.7%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3059.205
Maximum	7450
Range	7450
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1030.5199
Coefficient of variation (CV)	2.9680818
Kurtosis	7.7425593
Mean	347.20062
Median Absolute Deviation (MAD)	0
Skewness	2.9465252
Sum	2034595.7
Variance	1061971.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5195	88.7%
2520	17	0.3%
2240	10	0.2%
2640	9	0.2%
4440	9	0.2%
3500	9	0.2%
4800	8	0.1%
4488	7	0.1%
2800	6	0.1%
4560	6	0.1%
Other values (435)	584	10.0%

Value	Count	Frequency (%)
0	5195	88.7%
0.23	1	< 0.1%
11.5	1	< 0.1%
50	1	< 0.1%
99	1	< 0.1%
190.5	2	< 0.1%
228.87	1	< 0.1%
239	1	< 0.1%
281	1	< 0.1%
301	1	< 0.1%

Value	Count	Frequency (%)
7450	1	< 0.1%
7250	1	< 0.1%
5340	3	0.1%
5310	1	< 0.1%
5228	1	< 0.1%
5200	1	< 0.1%
5191.3	1	< 0.1%
5020	1	< 0.1%
4999	1	< 0.1%
4862	1	< 0.1%

Subtotal
Real number (ℝ)

High correlation

Distinct	403
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4597.0289

Minimum	995.24
Maximum	10197.68
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	995.24
5-th percentile	2250
Q1	3707.68
median	4285.71
Q3	5853.61
95-th percentile	6624.11
Maximum	10197.68
Range	9202.44
Interquartile range (IQR)	2145.93

Descriptive statistics

Standard deviation	1440.8683
Coefficient of variation (CV)	0.31343468
Kurtosis	0.31872993
Mean	4597.0289
Median Absolute Deviation (MAD)	1041.6
Skewness	0.34239951
Sum	26938589
Variance	2076101.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4645.54	278	4.7%
6081.25	220	3.8%
6118.25	201	3.4%
5840.11	143	2.4%
3729.11	124	2.1%
5039.46	114	1.9%
4947.82	108	1.8%
4263.96	105	1.8%
3707.68	103	1.8%
3995.04	102	1.7%
Other values (393)	4362	74.4%

Value	Count	Frequency (%)
995.24	1	< 0.1%
1071.43	1	< 0.1%
1119.64	4	0.1%
1178.57	11	0.2%
1275	2	< 0.1%
1285.71	2	< 0.1%
1285.72	1	< 0.1%
1325	5	0.1%
1392.86	3	0.1%
1399.12	1	< 0.1%

Value	Count	Frequency (%)
10197.68	34	0.6%
10174.11	4	0.1%
8346.04	8	0.1%
8326.96	8	0.1%
8034.82	1	< 0.1%
7656.25	1	< 0.1%
7656.24	3	0.1%
7570.54	5	0.1%
7527.68	6	0.1%
7501.96	14	0.2%

Discount
Real number (ℝ)

High correlation Zeros

Distinct	162
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1539.0243

Minimum	0
Maximum	4800
Zeros	1176
Zeros (%)	20.1%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1120
median	1548
Q3	2112
95-th percentile	3290
Maximum	4800
Range	4800
Interquartile range (IQR)	992

Descriptive statistics

Standard deviation	1033.9396
Coefficient of variation (CV)	0.67181499
Kurtosis	-0.35090255
Mean	1539.0243
Median Absolute Deviation (MAD)	564
Skewness	0.10588915
Sum	9018682.1
Variance	1069031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1176	20.1%
2600	278	4.7%
1700	278	4.7%
2112	249	4.2%
2016	168	2.9%
1480	143	2.4%
1980	130	2.2%
1560	121	2.1%
1210	114	1.9%
1190	110	1.9%
Other values (152)	3093	52.8%

Value	Count	Frequency (%)
0	1176	20.1%
48.64	1	< 0.1%
76.7	1	< 0.1%
78.83	1	< 0.1%
80	82	1.4%
135.73	1	< 0.1%
151.59	1	< 0.1%
175	2	< 0.1%
206.53	1	< 0.1%
217.06	1	< 0.1%

Value	Count	Frequency (%)
4800	4	0.1%
4410	22	0.4%
4340	39	0.7%
4200	3	0.1%
4000	5	0.1%
3738	8	0.1%
3660	4	0.1%
3600	6	0.1%
3560	8	0.1%
3540	12	0.2%

GST Tax Type Code
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	1591
Missing (%)	27.2%
Memory size	358.0 KiB

GST12	4269

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	21345
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GST12
2nd row	GST12
3rd row	GST12
4th row	GST12
5th row	GST12

Common Values

Value	Count	Frequency (%)
GST12	4269	72.8%
(Missing)	1591	27.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gst12	4269	100.0%

Most occurring characters

Value	Count	Frequency (%)
G	4269	20.0%
S	4269	20.0%
T	4269	20.0%
1	4269	20.0%
2	4269	20.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	12807	60.0%
Decimal Number	8538	40.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	4269	33.3%
S	4269	33.3%
T	4269	33.3%

Decimal Number

Value	Count	Frequency (%)
1	4269	50.0%
2	4269	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12807	60.0%
Common	8538	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	4269	33.3%
S	4269	33.3%
T	4269	33.3%

Common

Value	Count	Frequency (%)
1	4269	50.0%
2	4269	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21345	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	4269	20.0%
S	4269	20.0%
T	4269	20.0%
1	4269	20.0%
2	4269	20.0%

CGST
Real number (ℝ)

High correlation Zeros

Distinct	177
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.502348

Minimum	0
Maximum	400.66
Zeros	4926
Zeros (%)	84.1%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	209.94
Maximum	400.66
Range	400.66
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	70.832179
Coefficient of variation (CV)	2.4008997
Kurtosis	3.9107197
Mean	29.502348
Median Absolute Deviation (MAD)	0
Skewness	2.2410892
Sum	172883.76
Variance	5017.1976
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4926	84.1%
176.73	57	1.0%
208.88	50	0.9%
240.38	48	0.8%
134.94	31	0.5%
229.44	25	0.4%
167.52	23	0.4%
171.38	22	0.4%
151.98	21	0.4%
183.16	18	0.3%
Other values (167)	639	10.9%

Value	Count	Frequency (%)
0	4926	84.1%
20.93	1	< 0.1%
67.12	1	< 0.1%
67.18	1	< 0.1%
70.66	4	0.1%
73.88	1	< 0.1%
76.44	1	< 0.1%
77.09	4	0.1%
77.14	1	< 0.1%
79.44	1	< 0.1%

Value	Count	Frequency (%)
400.66	13	0.2%
321.38	2	< 0.1%
299.94	1	< 0.1%
286.07	1	< 0.1%
286.02	2	< 0.1%
278.57	1	< 0.1%
276.48	2	< 0.1%
267.8	1	< 0.1%
257.14	8	0.1%
257.09	6	0.1%

IGST
Real number (ℝ)

High correlation Zeros

Distinct	273
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	307.90994

Minimum	0
Maximum	964.18
Zeros	934
Zeros (%)	15.9%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	254.89
median	335.14
Q3	437.04
95-th percentile	494.89
Maximum	964.18
Range	964.18
Interquartile range (IQR)	182.15

Descriptive statistics

Standard deviation	161.22802
Coefficient of variation (CV)	0.5236207
Kurtosis	-0.030473274
Mean	307.90994
Median Absolute Deviation (MAD)	87.75
Skewness	-0.66341944
Sum	1804352.2
Variance	25994.473
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	934	15.9%
353.46	221	3.8%
417.75	220	3.8%
269.89	207	3.5%
480.75	199	3.4%
458.89	143	2.4%
247.39	116	2.0%
459.54	99	1.7%
451.18	92	1.6%
291.32	88	1.5%
Other values (263)	3541	60.4%

Value	Count	Frequency (%)
0	934	15.9%
47.9	2	< 0.1%
49.76	1	< 0.1%
128.46	2	< 0.1%
128.57	1	< 0.1%
134.25	5	0.1%
134.36	3	0.1%
141.32	30	0.5%
141.43	11	0.2%
147.75	6	0.1%

Value	Count	Frequency (%)
964.18	1	< 0.1%
824.89	4	0.1%
801.43	2	< 0.1%
801.32	21	0.4%
749.89	1	< 0.1%
696.32	1	< 0.1%
667.5	1	< 0.1%
642.75	1	< 0.1%
599.89	2	< 0.1%
578.46	1	< 0.1%

SGST
Real number (ℝ)

High correlation Zeros

Distinct	177
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.502348

Minimum	0
Maximum	400.66
Zeros	4926
Zeros (%)	84.1%
Negative	0
Negative (%)	0.0%
Memory size	45.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	209.94
Maximum	400.66
Range	400.66
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	70.832179
Coefficient of variation (CV)	2.4008997
Kurtosis	3.9107197
Mean	29.502348
Median Absolute Deviation (MAD)	0
Skewness	2.2410892
Sum	172883.76
Variance	5017.1976
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4926	84.1%
176.73	57	1.0%
208.88	50	0.9%
240.38	48	0.8%
134.94	31	0.5%
229.44	25	0.4%
167.52	23	0.4%
171.38	22	0.4%
151.98	21	0.4%
183.16	18	0.3%
Other values (167)	639	10.9%

Value	Count	Frequency (%)
0	4926	84.1%
20.93	1	< 0.1%
67.12	1	< 0.1%
67.18	1	< 0.1%
70.66	4	0.1%
73.88	1	< 0.1%
76.44	1	< 0.1%
77.09	4	0.1%
77.14	1	< 0.1%
79.44	1	< 0.1%

Value	Count	Frequency (%)
400.66	13	0.2%
321.38	2	< 0.1%
299.94	1	< 0.1%
286.07	1	< 0.1%
286.02	2	< 0.1%
278.57	1	< 0.1%
276.48	2	< 0.1%
267.8	1	< 0.1%
257.14	8	0.1%
257.09	6	0.1%

UTGST
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	332.0 KiB

0	5860

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5860
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5860	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5860	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5860	100.0%

CESS
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	332.0 KiB

0	5860

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5860
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5860	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5860	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5860	100.0%

CGST Rate
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	343.5 KiB

0.0	4926
6.0	933
2.5	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	17580
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	6.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	4926	84.1%
6.0	933	15.9%
2.5	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	4926	84.1%
6.0	933	15.9%
2.5	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	10785	61.3%
.	5860	33.3%
6	933	5.3%
2	1	< 0.1%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11720	66.7%
Other Punctuation	5860	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	10785	92.0%
6	933	8.0%
2	1	< 0.1%
5	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	17580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	10785	61.3%
.	5860	33.3%
6	933	5.3%
2	1	< 0.1%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	10785	61.3%
.	5860	33.3%
6	933	5.3%
2	1	< 0.1%
5	1	< 0.1%

IGST Rate
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	336.9 KiB

12	4923
0	934
5	3

Length

Max length	2
Median length	2
Mean length	1.8401024
Min length	1

Characters and Unicode

Total characters	10783
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	12
3rd row	12
4th row	12
5th row	12

Common Values

Value	Count	Frequency (%)
12	4923	84.0%
0	934	15.9%
5	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
12	4923	84.0%
0	934	15.9%
5	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	4923	45.7%
2	4923	45.7%
0	934	8.7%
5	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10783	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	4923	45.7%
2	4923	45.7%
0	934	8.7%
5	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10783	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	4923	45.7%
2	4923	45.7%
0	934	8.7%
5	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10783	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	4923	45.7%
2	4923	45.7%
0	934	8.7%
5	3	< 0.1%

SGST Rate
Categorical

High correlation Imbalance

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	343.5 KiB

0.0	4926
6.0	933
2.5	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	17580
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	6.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	4926	84.1%
6.0	933	15.9%
2.5	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	4926	84.1%
6.0	933	15.9%
2.5	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	10785	61.3%
.	5860	33.3%
6	933	5.3%
2	1	< 0.1%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11720	66.7%
Other Punctuation	5860	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	10785	92.0%
6	933	8.0%
2	1	< 0.1%
5	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	17580	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	10785	61.3%
.	5860	33.3%
6	933	5.3%
2	1	< 0.1%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17580	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	10785	61.3%
.	5860	33.3%
6	933	5.3%
2	1	< 0.1%
5	1	< 0.1%

UTGST Rate
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	332.0 KiB

0	5860

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5860
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5860	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5860	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5860	100.0%

CESS Rate
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	332.0 KiB

0	5860

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5860
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5860	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5860	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5860	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5860	100.0%

Sale Order Status
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	372.1 KiB

COMPLETE	5860

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	46880
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COMPLETE
2nd row	COMPLETE
3rd row	COMPLETE
4th row	COMPLETE
5th row	COMPLETE

Common Values

Value	Count	Frequency (%)
COMPLETE	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
complete	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	11720	25.0%
C	5860	12.5%
O	5860	12.5%
M	5860	12.5%
P	5860	12.5%
L	5860	12.5%
T	5860	12.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	46880	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	11720	25.0%
C	5860	12.5%
O	5860	12.5%
M	5860	12.5%
P	5860	12.5%
L	5860	12.5%
T	5860	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	46880	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	11720	25.0%
C	5860	12.5%
O	5860	12.5%
M	5860	12.5%
P	5860	12.5%
L	5860	12.5%
T	5860	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46880	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	11720	25.0%
C	5860	12.5%
O	5860	12.5%
M	5860	12.5%
P	5860	12.5%
L	5860	12.5%
T	5860	12.5%

GSTIN
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	412.2 KiB

09AAICN9819MIZL	5860

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	87900
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	09AAICN9819MIZL
2nd row	09AAICN9819MIZL
3rd row	09AAICN9819MIZL
4th row	09AAICN9819MIZL
5th row	09AAICN9819MIZL

Common Values

Value	Count	Frequency (%)
09AAICN9819MIZL	5860	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
09aaicn9819mizl	5860	100.0%

Most occurring characters

Value	Count	Frequency (%)
9	17580	20.0%
A	11720	13.3%
I	11720	13.3%
0	5860	6.7%
C	5860	6.7%
N	5860	6.7%
8	5860	6.7%
1	5860	6.7%
M	5860	6.7%
Z	5860	6.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	52740	60.0%
Decimal Number	35160	40.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	11720	22.2%
I	11720	22.2%
C	5860	11.1%
N	5860	11.1%
M	5860	11.1%
Z	5860	11.1%
L	5860	11.1%

Decimal Number

Value	Count	Frequency (%)
9	17580	50.0%
0	5860	16.7%
8	5860	16.7%
1	5860	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	52740	60.0%
Common	35160	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	11720	22.2%
I	11720	22.2%
C	5860	11.1%
N	5860	11.1%
M	5860	11.1%
Z	5860	11.1%
L	5860	11.1%

Common

Value	Count	Frequency (%)
9	17580	50.0%
0	5860	16.7%
8	5860	16.7%
1	5860	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87900	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	17580	20.0%
A	11720	13.3%
I	11720	13.3%
0	5860	6.7%
C	5860	6.7%
N	5860	6.7%
8	5860	6.7%
1	5860	6.7%
M	5860	6.7%
Z	5860	6.7%

SKU Name
Text

Distinct	91
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	639.7 KiB

Length

Max length	89
Median length	77
Mean length	54.766041
Min length	18

Characters and Unicode

Total characters	320929
Distinct characters	52
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	0.1%

Sample

1st row	Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta
2nd row	Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta
3rd row	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta
4th row	Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta
5th row	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta

Value	Count	Frequency (%)
with	6046	12.7%
kurta	3423	7.2%
	2900	6.1%
dupatta	2725	5.7%
embroidered	1970	4.1%
women	1864	3.9%
churidar	1857	3.9%
regular	1494	3.1%
ethnic	1025	2.1%
sequinned	957	2.0%
Other values (94)	23469	49.2%

Most occurring characters

Value	Count	Frequency (%)
	41870	13.0%
r	25494	7.9%
t	24652	7.7%
a	24399	7.6%
e	23982	7.5%
i	20749	6.5%
o	14730	4.6%
u	13561	4.2%
d	12746	4.0%
h	12224	3.8%
Other values (42)	106522	33.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	230976	72.0%
Uppercase Letter	43374	13.5%
Space Separator	41870	13.0%
Other Punctuation	2903	0.9%
Dash Punctuation	1603	0.5%
Decimal Number	203	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	25494	11.0%
t	24652	10.7%
a	24399	10.6%
e	23982	10.4%
i	20749	9.0%
o	14730	6.4%
u	13561	5.9%
d	12746	5.5%
h	12224	5.3%
n	11731	5.1%
Other values (15)	46708	20.2%

Uppercase Letter

Value	Count	Frequency (%)
W	6644	15.3%
C	5130	11.8%
D	4088	9.4%
S	3983	9.2%
E	3743	8.6%
K	3592	8.3%
P	3378	7.8%
T	2560	5.9%
R	1926	4.4%
O	1087	2.5%
Other values (12)	7243	16.7%

Other Punctuation

Value	Count	Frequency (%)
&	2900	99.9%
,	3	0.1%

Space Separator

Value	Count	Frequency (%)
	41870	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1603	100.0%

Decimal Number

Value	Count	Frequency (%)
3	203	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	274350	85.5%
Common	46579	14.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	25494	9.3%
t	24652	9.0%
a	24399	8.9%
e	23982	8.7%
i	20749	7.6%
o	14730	5.4%
u	13561	4.9%
d	12746	4.6%
h	12224	4.5%
n	11731	4.3%
Other values (37)	90082	32.8%

Common

Value	Count	Frequency (%)
	41870	89.9%
&	2900	6.2%
-	1603	3.4%
3	203	0.4%
,	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	320929	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	41870	13.0%
r	25494	7.9%
t	24652	7.7%
a	24399	7.6%
e	23982	7.5%
i	20749	6.5%
o	14730	4.6%
u	13561	4.2%
d	12746	4.0%
h	12224	3.8%
Other values (42)	106522	33.2%

Seller SKU Code
Text

Distinct	490
Distinct (%)	8.4%
Missing	0
Missing (%)	0.0%
Memory size	393.4 KiB

Length

Max length	17
Median length	16
Mean length	11.723891
Min length	9

Characters and Unicode

Total characters	68702
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	87 ?
Unique (%)	1.5%

Sample

1st row	ADGRN035-M
2nd row	ADKSET151-2XL
3rd row	ADKSET147-L
4th row	ADYLW036-S
5th row	ADKSET261-L

Value	Count	Frequency (%)
adcrdset159-s	125	2.1%
adcrdset159-m	120	2.0%
adkset148-m	87	1.5%
adcrdset159-l	83	1.4%
adkset157-s	81	1.4%
adkset157-m	81	1.4%
adcrdset159-xs	81	1.4%
adkset261-s	80	1.4%
adjmp145-s	76	1.3%
adkset148-l	73	1.2%
Other values (480)	4973	84.9%

Most occurring characters

Value	Count	Frequency (%)
D	7450	10.8%
A	6779	9.9%
S	6292	9.2%
-	5921	8.6%
1	4431	6.4%
T	4149	6.0%
E	3880	5.6%
L	3021	4.4%
K	2729	4.0%
2	2644	3.8%
Other values (23)	21406	31.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	44859	65.3%
Decimal Number	17922	26.1%
Dash Punctuation	5921	8.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	7450	16.6%
A	6779	15.1%
S	6292	14.0%
T	4149	9.2%
E	3880	8.6%
L	3021	6.7%
K	2729	6.1%
X	2202	4.9%
M	1809	4.0%
R	1796	4.0%
Other values (12)	4752	10.6%

Decimal Number

Value	Count	Frequency (%)
1	4431	24.7%
2	2644	14.8%
0	2333	13.0%
5	1981	11.1%
6	1598	8.9%
4	1492	8.3%
7	1019	5.7%
8	875	4.9%
9	855	4.8%
3	694	3.9%

Dash Punctuation

Value	Count	Frequency (%)
-	5921	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44859	65.3%
Common	23843	34.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	7450	16.6%
A	6779	15.1%
S	6292	14.0%
T	4149	9.2%
E	3880	8.6%
L	3021	6.7%
K	2729	6.1%
X	2202	4.9%
M	1809	4.0%
R	1796	4.0%
Other values (12)	4752	10.6%

Common

Value	Count	Frequency (%)
-	5921	24.8%
1	4431	18.6%
2	2644	11.1%
0	2333	9.8%
5	1981	8.3%
6	1598	6.7%
4	1492	6.3%
7	1019	4.3%
8	875	3.7%
9	855	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	68702	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	7450	10.8%
A	6779	9.9%
S	6292	9.2%
-	5921	8.6%
1	4431	6.4%
T	4149	6.0%
E	3880	5.6%
L	3021	4.4%
K	2729	4.0%
2	2644	3.8%
Other values (23)	21406	31.2%

Shipping Courier Status
Categorical

High correlation Imbalance Missing

Distinct	10
Distinct (%)	0.2%
Missing	98
Missing (%)	1.7%
Memory size	390.8 KiB

DELIVERED	4815
COURIER_RETURN-DELIVERED	679
COURIER_RETURN-RTO-DELIVERED	156
SHIPPED	69
COURIER_RETURN-CONFIRMED	22
Other values (5)	21

Length

Max length	28
Median length	9
Mean length	11.333565
Min length	7

Characters and Unicode

Total characters	65304
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DELIVERED
2nd row	DELIVERED
3rd row	DELIVERED
4th row	DELIVERED
5th row	DELIVERED

Common Values

Value	Count	Frequency (%)
DELIVERED	4815	82.2%
COURIER_RETURN-DELIVERED	679	11.6%
COURIER_RETURN-RTO-DELIVERED	156	2.7%
SHIPPED	69	1.2%
COURIER_RETURN-CONFIRMED	22	0.4%
OUTFORDELIVERY	9	0.2%
INTRANSIT	7	0.1%
SHIPMENTHELD	2	< 0.1%
COURIER_RETURN-RTO-INTRANSIT	2	< 0.1%
COURIER_RETURN-RTO-FAILED	1	< 0.1%
(Missing)	98	1.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
delivered	4815	83.6%
courier_return-delivered	679	11.8%
courier_return-rto-delivered	156	2.7%
shipped	69	1.2%
courier_return-confirmed	22	0.4%
outfordelivery	9	0.2%
intransit	7	0.1%
shipmentheld	2	< 0.1%
courier_return-rto-intransit	2	< 0.1%
courier_return-rto-failed	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	18784	28.8%
D	11403	17.5%
R	9298	14.2%
I	6631	10.2%
L	5662	8.7%
V	5659	8.7%
U	1729	2.6%
O	1059	1.6%
T	1048	1.6%
-	1019	1.6%
Other values (10)	3012	4.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	63425	97.1%
Dash Punctuation	1019	1.6%
Connector Punctuation	860	1.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	18784	29.6%
D	11403	18.0%
R	9298	14.7%
I	6631	10.5%
L	5662	8.9%
V	5659	8.9%
U	1729	2.7%
O	1059	1.7%
T	1048	1.7%
N	902	1.4%
Other values (8)	1250	2.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1019	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	860	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	63425	97.1%
Common	1879	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	18784	29.6%
D	11403	18.0%
R	9298	14.7%
I	6631	10.5%
L	5662	8.9%
V	5659	8.9%
U	1729	2.7%
O	1059	1.7%
T	1048	1.7%
N	902	1.4%
Other values (8)	1250	2.0%

Common

Value	Count	Frequency (%)
-	1019	54.2%
_	860	45.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65304	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	18784	28.8%
D	11403	17.5%
R	9298	14.2%
I	6631	10.2%
L	5662	8.7%
V	5659	8.7%
U	1729	2.6%
O	1059	1.6%
T	1048	1.6%
-	1019	1.6%
Other values (10)	3012	4.6%

Shipping Tracking Status
Categorical

High correlation Missing

Distinct	5
Distinct (%)	0.1%
Missing	98
Missing (%)	1.7%
Memory size	423.3 KiB

STATUS_NOT_DEFINED	4112
DELIVERED	933
RTO_DELIVERED_TO_SELLER	679
RTO_INITIATED	22
PENDING_IN_TRANSIT	16

Length

Max length	23
Median length	18
Mean length	17.112808
Min length	9

Characters and Unicode

Total characters	98604
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DELIVERED
2nd row	DELIVERED
3rd row	DELIVERED
4th row	STATUS_NOT_DEFINED
5th row	STATUS_NOT_DEFINED

Common Values

Value	Count	Frequency (%)
STATUS_NOT_DEFINED	4112	70.2%
DELIVERED	933	15.9%
RTO_DELIVERED_TO_SELLER	679	11.6%
RTO_INITIATED	22	0.4%
PENDING_IN_TRANSIT	16	0.3%
(Missing)	98	1.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
status_not_defined	4112	71.4%
delivered	933	16.2%
rto_delivered_to_seller	679	11.8%
rto_initiated	22	0.4%
pending_in_transit	16	0.3%

Most occurring characters

Value	Count	Frequency (%)
E	14456	14.7%
T	13792	14.0%
D	11486	11.6%
_	10315	10.5%
S	8919	9.0%
N	8310	8.4%
I	5838	5.9%
O	5492	5.6%
A	4150	4.2%
U	4112	4.2%
Other values (6)	11734	11.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	88289	89.5%
Connector Punctuation	10315	10.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	14456	16.4%
T	13792	15.6%
D	11486	13.0%
S	8919	10.1%
N	8310	9.4%
I	5838	6.6%
O	5492	6.2%
A	4150	4.7%
U	4112	4.7%
F	4112	4.7%
Other values (5)	7622	8.6%

Connector Punctuation

Value	Count	Frequency (%)
_	10315	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	88289	89.5%
Common	10315	10.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	14456	16.4%
T	13792	15.6%
D	11486	13.0%
S	8919	10.1%
N	8310	9.4%
I	5838	6.6%
O	5492	6.2%
A	4150	4.7%
U	4112	4.7%
F	4112	4.7%
Other values (5)	7622	8.6%

Common

Value	Count	Frequency (%)
_	10315	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	98604	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	14456	14.7%
T	13792	14.0%
D	11486	11.6%
_	10315	10.5%
S	8919	9.0%
N	8310	8.4%
I	5838	5.9%
O	5492	5.6%
A	4150	4.2%
U	4112	4.2%
Other values (6)	11734	11.9%

Interactions

Correlations

	Billing Address Id	Billing Address Pincode	Billing Address State	CGST	CGST Rate	Channel Name	Discount	IGST	IGST Rate	Item Type Color	MRP	Prepaid Amount	SGST	SGST Rate	Selling Price	Shipping Address Id	Shipping Address Pincode	Shipping Address State	Shipping Courier Status	Shipping Tracking Status	Subtotal	Total Price
Billing Address Id	1.000	0.013	0.076	0.023	0.059	0.134	0.172	0.071	0.057	0.155	0.164	-0.068	0.023	0.059	0.126	1.000	0.013	0.076	0.091	0.119	0.173	0.126
Billing Address Pincode	0.013	1.000	0.878	-0.318	0.637	0.031	0.021	0.151	0.638	0.057	-0.034	-0.035	-0.318	0.637	-0.063	0.013	1.000	0.878	0.026	0.024	-0.024	-0.063
Billing Address State	0.076	0.878	1.000	0.324	0.702	0.091	0.053	0.335	0.703	0.116	0.041	0.000	0.324	0.702	0.026	0.076	0.878	1.000	0.046	0.063	0.066	0.026
CGST	0.023	-0.318	0.324	1.000	0.706	0.098	0.038	-0.632	0.706	0.320	0.047	-0.020	1.000	0.706	0.043	0.023	-0.318	0.324	0.000	0.034	0.049	0.043
CGST Rate	0.059	0.637	0.702	0.706	1.000	0.005	0.266	0.705	0.707	0.039	0.353	0.000	0.706	1.000	0.057	0.059	0.637	0.702	0.080	0.000	0.116	0.057
Channel Name	0.134	0.031	0.091	0.098	0.005	1.000	0.951	0.138	0.006	0.184	0.144	0.697	0.098	0.005	0.107	0.134	0.031	0.091	0.390	0.874	0.697	0.107
Discount	0.172	0.021	0.053	0.038	0.266	0.951	1.000	0.128	0.308	0.496	0.472	-0.490	0.038	0.266	0.215	0.172	0.021	0.053	0.126	0.416	0.833	0.215
IGST	0.071	0.151	0.335	-0.632	0.705	0.138	0.128	1.000	0.706	0.552	0.548	-0.000	-0.632	0.705	0.707	0.071	0.151	0.335	0.058	0.083	0.456	0.707
IGST Rate	0.057	0.638	0.703	0.706	0.707	0.006	0.308	0.706	1.000	0.039	0.612	0.084	0.706	0.707	0.102	0.057	0.638	0.703	0.000	0.000	0.201	0.102
Item Type Color	0.155	0.057	0.116	0.320	0.039	0.184	0.496	0.552	0.039	1.000	0.611	0.146	0.320	0.039	0.702	0.155	0.057	0.116	0.079	0.150	0.491	0.702
MRP	0.164	-0.034	0.041	0.047	0.353	0.144	0.472	0.548	0.612	0.611	1.000	-0.003	0.047	0.353	0.788	0.164	-0.034	0.041	0.042	0.060	0.772	0.788
Prepaid Amount	-0.068	-0.035	0.000	-0.020	0.000	0.697	-0.490	-0.000	0.084	0.146	-0.003	1.000	-0.020	0.000	-0.028	-0.068	-0.035	0.000	0.051	0.364	-0.400	-0.028
SGST	0.023	-0.318	0.324	1.000	0.706	0.098	0.038	-0.632	0.706	0.320	0.047	-0.020	1.000	0.706	0.043	0.023	-0.318	0.324	0.000	0.034	0.049	0.043
SGST Rate	0.059	0.637	0.702	0.706	1.000	0.005	0.266	0.705	0.707	0.039	0.353	0.000	0.706	1.000	0.057	0.059	0.637	0.702	0.080	0.000	0.116	0.057
Selling Price	0.126	-0.063	0.026	0.043	0.057	0.107	0.215	0.707	0.102	0.702	0.788	-0.028	0.043	0.057	1.000	0.126	-0.063	0.026	0.043	0.040	0.667	1.000
Shipping Address Id	1.000	0.013	0.076	0.023	0.059	0.134	0.172	0.071	0.057	0.155	0.164	-0.068	0.023	0.059	0.126	1.000	0.013	0.076	0.091	0.119	0.173	0.126
Shipping Address Pincode	0.013	1.000	0.878	-0.318	0.637	0.031	0.021	0.151	0.638	0.057	-0.034	-0.035	-0.318	0.637	-0.063	0.013	1.000	0.878	0.026	0.024	-0.024	-0.063
Shipping Address State	0.076	0.878	1.000	0.324	0.702	0.091	0.053	0.335	0.703	0.116	0.041	0.000	0.324	0.702	0.026	0.076	0.878	1.000	0.046	0.063	0.066	0.026
Shipping Courier Status	0.091	0.026	0.046	0.000	0.080	0.390	0.126	0.058	0.000	0.079	0.042	0.051	0.000	0.080	0.043	0.091	0.026	0.046	1.000	0.867	0.099	0.043
Shipping Tracking Status	0.119	0.024	0.063	0.034	0.000	0.874	0.416	0.083	0.000	0.150	0.060	0.364	0.034	0.000	0.040	0.119	0.024	0.063	0.867	1.000	0.299	0.040
Subtotal	0.173	-0.024	0.066	0.049	0.116	0.697	0.833	0.456	0.201	0.491	0.772	-0.400	0.049	0.116	0.667	0.173	-0.024	0.066	0.099	0.299	1.000	0.667
Total Price	0.126	-0.063	0.026	0.043	0.057	0.107	0.215	0.707	0.102	0.702	0.788	-0.028	0.043	0.057	1.000	0.126	-0.063	0.026	0.043	0.040	0.667	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Shipping Address Id	Category	Invoice Code	Invoice Created	Shipping Address City	Shipping Address State	Shipping Address Country	Shipping Address Pincode	Billing Address Id	Billing Address City	Billing Address State	Billing Address Country	Billing Address Pincode	Shipping Method	Item SKU Code	Item Type Name	Item Type Color	Channel Name	Gift Wrap	HSN Code	MRP	Total Price	Selling Price	Cost Price	Prepaid Amount	Subtotal	Discount	GST Tax Type Code	CGST	IGST	SGST	CGST Rate	IGST Rate	SGST Rate	Sale Order Status	GSTIN	SKU Name	Seller SKU Code	Shipping Courier Status	Shipping Tracking Status
0	19970813	Default	NIMAT25F01090	31/12/2024 09:45	Raebareli	Uttar Pradesh	IN	229001	19970814	Raebareli	Uttar Pradesh	IN	229001	STD	ADGRN035-M	Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta	Green	NYKAA_FASHION	False	62045300.0	5999.0	2700.0	2700.0	NaN	2670.0	2710.72	300.0	NaN	144.64	0.00	144.64	6.0	0	6.0	COMPLETE	09AAICN9819MIZL	Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta	ADGRN035-M	DELIVERED	DELIVERED
1	19984900	Default	NIMAT25F01091	31/12/2024 09:45	Phagwara	Punjab	IN	144410	19984901	Phagwara	Punjab	IN	144410	STD	ADKSET151-2XL	Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta	NaN	NYKAA_FASHION	False	62045300.0	6599.0	4356.0	4356.0	NaN	0.0	3889.29	0.0	GST12	0.00	466.71	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta	ADKSET151-2XL	DELIVERED	DELIVERED
2	19986570	Default	NIMAT25F01092	31/12/2024 09:45	Berhampore	West Bengal	IN	742122	19986571	Berhampore	West Bengal	IN	742122	STD	ADKSET147-L	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	Cream	NYKAA_FASHION	False	62045300.0	6999.0	3500.0	3500.0	NaN	0.0	3125.00	0.0	NaN	0.00	375.00	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	ADKSET147-L	DELIVERED	DELIVERED
3	19987349	Default	I0925NC000006459	31/12/2024 09:44	Hyderabad	Telangana	IN	500075	19987349	Hyderabad	Telangana	IN	500075	STD	ADYLW036-S	Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta	NaN	MYNTRAPPMP	False	62045300.0	6499.0	3639.0	3639.0	NaN	0.0	6109.11	2860.0	GST12	0.00	389.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta	ADYLW036-S	DELIVERED	STATUS_NOT_DEFINED
4	19971790	Default	I0925NC000006454	31/12/2024 09:44	Kolkata	West Bengal	IN	700115	19971790	Kolkata	West Bengal	IN	700115	STD	ADKSET261-L	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta	NaN	MYNTRAPPMP	False	62045300.0	6299.0	4283.0	4283.0	NaN	0.0	5840.11	2016.0	GST12	0.00	458.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta	ADKSET261-L	DELIVERED	STATUS_NOT_DEFINED
5	19972169	Default	I0925NC000006461	31/12/2024 09:44	Jaipur	Rajasthan	IN	302015	19972169	Jaipur	Rajasthan	IN	302015	STD	ADKSET147-XS	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	Cream	MYNTRAPPMP	False	62045300.0	6999.0	3499.0	3499.0	NaN	0.0	6624.11	3500.0	NaN	0.00	374.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	ADKSET147A-XS	DELIVERED	STATUS_NOT_DEFINED
6	19977759	Default	I0925NC000006462	31/12/2024 09:44	Surat	Gujarat	IN	395004	19977759	Surat	Gujarat	IN	395004	STD	ADCRDSET163-S	Embroidered Round Neck Top With Palazzos	NaN	MYNTRAPPMP	False	62045300.0	5499.0	4289.0	4289.0	NaN	0.0	5039.46	1210.0	GST12	0.00	459.54	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Embroidered Round Neck Top With Palazzos	ADCRDSET163-S	DELIVERED	STATUS_NOT_DEFINED
7	19978570	Default	I0925NC000006453	31/12/2024 09:44	New Delhi	Delhi	IN	110092	19978570	New Delhi	Delhi	IN	110092	STD	ADKSET147-XL	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	Cream	MYNTRAPPMP	False	62045300.0	6999.0	3499.0	3499.0	NaN	0.0	6624.11	3500.0	NaN	0.00	374.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	ADKSET147A-XL	DELIVERED	STATUS_NOT_DEFINED
8	19981812	Default	I0925NC000006455	31/12/2024 09:44	Surat	Gujarat	IN	395004	19981812	Surat	Gujarat	IN	395004	STD	ADCRDSET159-L	Brocade Co-Ord Set	NaN	MYNTRAPPMP	False	62045300.0	4999.0	3299.0	3299.0	NaN	0.0	4645.54	1700.0	GST12	0.00	353.46	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Brocade Co-Ord Set	ADCRDSET159-L	DELIVERED	STATUS_NOT_DEFINED
9	19984011	Default	I0925NC000006451	31/12/2024 09:44	Gurgaon	Haryana	IN	122505	19984011	Gurgaon	Haryana	IN	122505	STD	ADCRDSET159-XL	Brocade Co-Ord Set	NaN	MYNTRAPPMP	False	62045300.0	4999.0	3299.0	3299.0	NaN	0.0	4645.54	1700.0	GST12	0.00	353.46	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Brocade Co-Ord Set	ADCRDSET159-XL	DELIVERED	STATUS_NOT_DEFINED

	Shipping Address Id	Category	Invoice Code	Invoice Created	Shipping Address City	Shipping Address State	Shipping Address Country	Shipping Address Pincode	Billing Address Id	Billing Address City	Billing Address State	Billing Address Country	Billing Address Pincode	Shipping Method	Item SKU Code	Item Type Name	Item Type Color	Channel Name	Gift Wrap	HSN Code	MRP	Total Price	Selling Price	Cost Price	Subtotal	Discount	GST Tax Type Code	CGST	IGST	SGST	CGST Rate	IGST Rate	SGST Rate	Sale Order Status	GSTIN	SKU Name	Seller SKU Code	Shipping Courier Status	Shipping Tracking Status
5850	17828753	Default	I0925NC000003789	1/10/2024 9:59	Gautam Buddha Nagar	Uttar Pradesh	IN	201301	17828753	Gautam Buddha Nagar	Uttar Pradesh	IN	201301	STD	ADKSET261-M	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta	NaN	MYNTRAPPMP	False	62045300.0	6299.0	4283.0	4283.0	NaN	5840.12	2016.0	GST12	229.44	0.00	229.44	6.0	0	6.0	COMPLETE	09AAICN9819MIZL	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta	ADKSET261-M	COURIER_RETURN-DELIVERED	RTO_DELIVERED_TO_SELLER
5851	17829195	Default	I0925NC000003790	1/10/2024 9:59	Bengaluru	Karnataka	IN	560069	17829195	Bengaluru	Karnataka	IN	560069	STD	ADCRDSET159-XS	Brocade Co-Ord Set	NaN	MYNTRAPPMP	False	62045300.0	4999.0	3299.0	3299.0	NaN	4645.54	1700.0	GST12	0.00	353.46	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Brocade Co-Ord Set	ADCRDSET159-XS	COURIER_RETURN-DELIVERED	RTO_DELIVERED_TO_SELLER
5852	17831361	Default	I0925NC000003791	1/10/2024 9:59	Kolkata,	West Bengal	IN	700004	17831361	Kolkata,	West Bengal	IN	700004	STD	ADKSET236-L	Women Panelled Kurta with Trousers	Green	MYNTRAPPMP	False	62045300.0	5999.0	4079.0	4079.0	NaN	5561.96	1920.0	NaN	0.00	437.04	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Panelled Kurta with Trousers	ADKSET236-L	DELIVERED	STATUS_NOT_DEFINED
5853	17831437	Default	I0925NC000003766	1/10/2024 9:59	Kolkata,	West Bengal	IN	700004	17831437	Kolkata,	West Bengal	IN	700004	STD	ADKSET261-XXL	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt	NaN	MYNTRAPPMP	False	62045300.0	6299.0	4283.0	4283.0	NaN	5840.11	2016.0	GST12	0.00	458.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt	ADKSET261-XXL	DELIVERED	STATUS_NOT_DEFINED
5854	17831642	Default	I0925NC000003778	1/10/2024 9:59	Mumbai	Maharashtra	IN	400042	17831642	Mumbai	Maharashtra	IN	400042	STD	ADKSET261-XXL	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt	NaN	MYNTRAPPMP	False	62045300.0	6299.0	4283.0	4283.0	NaN	5840.11	2016.0	GST12	0.00	458.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt	ADKSET261-XXL	COURIER_RETURN-DELIVERED	RTO_DELIVERED_TO_SELLER
5855	17832698	Default	I0925NC000003767	1/10/2024 9:59	Jallandhar	Punjab	IN	144022	17832698	Jallandhar	Punjab	IN	144022	STD	ADJMP145-M	Floral Printed Culotte Jumpsuit	NaN	MYNTRAPPMP	False	62045300.0	4599.0	3127.0	3127.0	NaN	4263.96	1472.0	GST12	0.00	335.04	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Floral Printed Culotte Jumpsuit	ADJMP145-M	DELIVERED	STATUS_NOT_DEFINED
5856	17834756	Default	I0925NC000003793	1/10/2024 9:59	Kolkata	West Bengal	IN	743144	17834756	Kolkata	West Bengal	IN	743144	STD	ADKSET147-XS	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	Cream	MYNTRAPPMP	False	62045300.0	6999.0	3499.0	3499.0	NaN	6624.11	3500.0	NaN	0.00	374.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta	ADKSET147A-XS	DELIVERED	STATUS_NOT_DEFINED
5857	17835046	Default	I0925NC000003769	1/10/2024 9:59	Nagpur	Maharashtra	IN	440033	17835046	Nagpur	Maharashtra	IN	440033	STD	ADBLU020-M	Woven Design Lapel Collar Jacket and Organza Palazzo	NaN	MYNTRAPPMP	False	62045300.0	6499.0	3639.0	3639.0	NaN	6109.11	2860.0	GST12	0.00	389.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Woven Design Lapel Collar Jacket and Organza Palazzo	ADBLU020-M	DELIVERED	STATUS_NOT_DEFINED
5858	17835046	Default	I0925NC000003769	1/10/2024 9:59	Nagpur	Maharashtra	IN	440033	17835046	Nagpur	Maharashtra	IN	440033	STD	ADBLU020-XL	Woven Design Lapel Collar Jacket and Organza Palazzo	NaN	MYNTRAPPMP	False	62045300.0	6499.0	3639.0	3639.0	NaN	6109.11	2860.0	GST12	0.00	389.89	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Woven Design Lapel Collar Jacket and Organza Palazzo	ADBLU020-XL	DELIVERED	STATUS_NOT_DEFINED
5859	17835851	Default	I0925NC000003783	1/10/2024 9:59	Kolkata	West Bengal	IN	700078	17835851	Kolkata	West Bengal	IN	700078	STD	ADKSET240-XS	Women High Slit Pure Silk Kurta with Trousers	NaN	MYNTRAPPMP	False	62045300.0	3999.0	2719.0	2719.0	NaN	3707.68	1280.0	GST12	0.00	291.32	0.00	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women High Slit Pure Silk Kurta with Trousers	ADKSET240-XS	DELIVERED	STATUS_NOT_DEFINED

Duplicate rows

Most frequently occurring

	Shipping Address Id	Category	Invoice Code	Invoice Created	Shipping Address City	Shipping Address State	Shipping Address Country	Shipping Address Pincode	Billing Address Id	Billing Address City	Billing Address State	Billing Address Country	Billing Address Pincode	Shipping Method	Item SKU Code	Item Type Name	Item Type Color	Channel Name	Gift Wrap	HSN Code	MRP	Total Price	Selling Price	Subtotal	Discount	GST Tax Type Code	CGST	IGST	SGST	CGST Rate	IGST Rate	SGST Rate	Sale Order Status	GSTIN	SKU Name	Seller SKU Code	Shipping Courier Status	Shipping Tracking Status	# duplicates
0	17147660	Default	I0925NC000003225	28/08/2024 09:54	Jamshedpur	Jharkhand	IN	832110	17147660	Jamshedpur	Jharkhand	IN	832110	STD	ADKSET116-2XL	Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta	NaN	MYNTRAPPMP	False	62045300.0	4999.0	2899.0	2899.0	4688.395	2100.0	GST12	0.000	310.605	0.000	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta	ADKSET116-2XL	DELIVERED	STATUS_NOT_DEFINED	2
1	17277998	Default	I0925NC000003342	9/4/2024 10:01	Bhavnagar	Gujarat	IN	364002	17277998	Bhavnagar	Gujarat	IN	364002	STD	ADJMP145-XS	Floral Printed Culotte Jumpsuit	NaN	MYNTRAPPMP	False	62045300.0	4599.0	3219.0	3219.0	4254.105	1380.0	GST12	0.000	344.895	0.000	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Floral Printed Culotte Jumpsuit	ADJMP145-XS	DELIVERED	STATUS_NOT_DEFINED	2
2	18259525	Default	I0925NC000004333	17/10/2024 10:01	New Delhi	Delhi	IN	110043	18259525	New Delhi	Delhi	IN	110043	STD	ADCRDSET188-S	Printed Tunic With Trousers	NaN	MYNTRAPPMP	False	62045300.0	2999.0	1979.0	1979.0	2786.965	1020.0	GST12	0.000	212.035	0.000	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Printed Tunic With Trousers	ADCRDSET188-S	COURIER_RETURN-DELIVERED	RTO_DELIVERED_TO_SELLER	2
3	18398525	Default	I0925NC000004603	22/10/2024 17:36	Rampur	Uttar Pradesh	IN	244901	18398525	Rampur	Uttar Pradesh	IN	244901	STD	ADKSET161A-L	Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta	Red	MYNTRAPPMP	False	62045300.0	NaN	3709.0	3709.0	6601.600	3290.0	NaN	198.700	0.000	198.700	6.0	0	6.0	COMPLETE	09AAICN9819MIZL	Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta	ADKSET161A-L	DELIVERED	STATUS_NOT_DEFINED	2
4	18530461	Default	I0925NC000004899	26/10/2024 17:15	Lucknow	Uttar Pradesh	IN	226022	18530461	Lucknow	Uttar Pradesh	IN	226022	STD	ADCRDSET263-M	Printed Tunic With Palazzzos	NaN	MYNTRAPPMP	False	62045300.0	5999.0	4439.0	4439.0	5523.400	1560.0	GST12	237.800	0.000	237.800	6.0	0	6.0	COMPLETE	09AAICN9819MIZL	Printed Tunic With Palazzzos	ADCRDSET263-M	DELIVERED	STATUS_NOT_DEFINED	2
5	18634020	Default	I0925NC000005015	30/10/2024 16:53	Delhi	Delhi	IN	110093	18634020	Delhi	Delhi	IN	110093	STD	ADKSET116-XL	Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta	NaN	MYNTRAPPMP	False	62045300.0	4999.0	2699.0	2699.0	4709.820	2300.0	GST12	0.000	289.180	0.000	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta	ADKSET116-XL	COURIER_RETURN-DELIVERED	RTO_DELIVERED_TO_SELLER	2
6	18775768	Default	I0925NC000005198	7/11/2024 9:51	Bhagalpur	Bihar	IN	812002	18775768	Bhagalpur	Bihar	IN	812002	STD	ADKSET161A-XS	Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta	Red	MYNTRAPPMP	False	62045300.0	NaN	3709.0	3709.0	6601.605	3290.0	NaN	0.000	397.395	0.000	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta	ADKSET161A-XS	COURIER_RETURN-DELIVERED	RTO_DELIVERED_TO_SELLER	2
7	19384236	Default	I0925NC000005934	3/12/2024 10:21	Nawada	Bihar	IN	805131	19384236	Nawada	Bihar	IN	805131	STD	ADKSET148-M	Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta	Burgandy	MYNTRAPPMP	False	62045300.0	6599.0	4487.0	4487.0	6118.250	2112.0	NaN	0.000	480.750	0.000	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta	ADKSET148-M	DELIVERED	STATUS_NOT_DEFINED	2
8	20312124	Default	I0925NC000006798	18/01/2025 09:48	Lucknow	Uttar Pradesh	IN	226004	20312124	Lucknow	Uttar Pradesh	IN	226004	STD	ADKSET148-L	Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta	Burgandy	MYNTRAPPMP	False	62045300.0	6599.0	4487.0	4487.0	6118.250	2112.0	GST12	240.375	0.000	240.375	6.0	0	6.0	COMPLETE	09AAICN9819MIZL	Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta	ADKSET148-L	COURIER_RETURN-DELIVERED	RTO_DELIVERED_TO_SELLER	2
9	20900823	Default	I0925NC000007693	21/02/2025 10:02	Bhopal	Madhya Pradesh	IN	462001	20900823	Bhopal	Madhya Pradesh	IN	462001	STD	ADKSET148-M	Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta	Burgandy	MYNTRAPPMP	False	62045300.0	6599.0	4487.0	4487.0	6118.250	2112.0	NaN	0.000	480.750	0.000	0.0	12	0.0	COMPLETE	09AAICN9819MIZL	Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta	ADKSET148-M	SHIPPED	STATUS_NOT_DEFINED	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter